存储过程中[ATE2706] AS ECW是什么意思

来源：百度知道编辑：UC知道时间：2024/07/04 23:53:07

create PROCEDURE SP_LY_LiuLiang(@Date smalldatetime,@GL int)
AS
if(@GL=1)
SELECT str(DATEPART(HH,[DTIME]))+':00'AS [TIME],
[APT2704] AS ECY,
[ATE2706] AS ECW,
[APT2705] AS GJ2Y,
[ATE2709] AS GJ2W,
[APT2701] AS YCY,
[ATE2701] AS YCW,
[APT2702] AS GJ1Y,
[ATE2704] AS GJ1W,
[ATDBY01QJ18] AS GJ2SW,
[AAI180102] AS GJ1SW,
[ATE2911] AS GJ2RW,
[ATE2914] AS GJ2CW,
[ATE2917] AS GJ1CW,
[AFT0901_1] AS ZGSW,
[APT2912] AS GMY,
[ATE2907] AS GCMW,
[AFT1004A] AS AZSP,
[AFT1004B] AS BZSP,
[AFT1005A] AS AZZP,
[AFT1005B] AS BZZP,
[AFT1001A] AS A1JW,
[AFT1001B] AS B1JW,
[AFT1002A] AS A2JW,
[AFT1002B] AS B2JW
FROM [LY_1liuliang] where Dtime between DateAdd(hh,2,@Date) and DateAdd(hh,1,DateAdd(dd,1,@Date)) order by [Time]
ELSE IF(@GL=2)

[ATE2706] AS ECW
他的意思就是原来[ATE2706]列的名称在显示结果时显示自定义的名字ECW，
而不是原来的列名[ATE2706]，这样有助于让读者一看就知道那列是什么意思，说白了就是把原来的列起了一个别名。

SQL 中创建存储过程 ASP中存储过程如何调用? 在ASP中调用sql存储过程 vb中使用SQL SERVER存储过程 SQL存储过程中创建视图在vb中调用sql存储过程关于存储过程中执行字符串请问ASP中如何调用存储过程? PB中存储过程的调用? 存储过程中能修改视图吗？